/**
 * Copyright &copy; 2012-2014 <a href="https://github.com/thinkgem/jeesite">JeeSite</a> All rights reserved.
 */
package com.thinkgem.jeesite.modules.employee.dao;

import java.util.Date;
import java.util.List;

import com.thinkgem.jeesite.common.persistence.CrudDao;
import com.thinkgem.jeesite.common.persistence.annotation.MyBatisDao;
import com.thinkgem.jeesite.modules.employee.entity.AttendanceRecords;
import org.apache.ibatis.annotations.Param;

/**
 * 考勤结果统计DAO接口
 * @author pan.zhou
 * @version 2017-07-21
 */
@MyBatisDao
public interface AttendanceRecordsDao extends CrudDao<AttendanceRecords> {
    
    /**
     * 
     * 查询员工异常打卡 
     * @param attendanceRecords
     * @return
     */
    List<AttendanceRecords> queryExceptionEmployee(AttendanceRecords attendanceRecords);

    /**
     * 根据仓库和时间查询出类型用的工时
     * @param date
     * @param name
     * @return
     */
    List<AttendanceRecords> queryAllByOutSourceEmloee(@Param("date") Date date, @Param("ckName") String name, @Param("userType") String userType);

    /**
     * 统计
     * @param monday
     * @param date
     * @param name
     * @param typeCode
     * @return
     */
    Double queryTotalWeekByOutSourceEmloeeAndWeek(@Param("monday")Date monday,@Param("date") Date date,@Param("employeenumber") String number);
}